Skip to main content

Limitations and considerations

The following limitations apply when using Google Cloud BigQuery as a target in a Replicate task:

  • The following DDLs are not supported:
    • Drop column
    • Rename column
    • Change column data type
    • Rename table
  • Capturing changes from source tables without a Primary Key or Unique Index is not supported. If you need to capture changes from such tables, you can add a Primary Key using a transformation. Additionally, Primary Key or Unique Index columns cannot contain NULLs. If you are aware that such columns will be populated with NULL values, define a transformation to change the NULLs to non-nullable values.

  • The Transactional apply Change Processing Mode is not supported.
  • The Allow unlimited LOB size LOB handling option is not supported.
  • The Log record to the exceptions table error handling option for apply conflicts and data errors is not supported.

  • With the following task settings configuration, the replication task will perform a DELETE operation followed by an INSERT instead of an UPDATE:

    As Google Cloud BigQuery does not support rollback, in the event that the replication task is unable to insert the updated row, the data will be deleted from the target.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!